﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="TalesDataSet" targetNamespace="http://tempuri.org/TalesDataSet.xsd" xmlns:mstns="http://tempuri.org/TalesDataSet.xsd" xmlns="http://tempuri.org/TalesDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="TalesConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="TalesConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ListOfTale.Properties.Settings.GlobalReference.Default.TalesConnectionString" Provider="System.Data.SQLite" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AuthorTableAdapter" GeneratorDataComponentClassName="AuthorTableAdapter" Name="Author" UserDataComponentName="AuthorTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectName="main.Author" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Author] WHERE (((@IsNull_Language = 1 AND [Language] IS NULL) OR ([Language] = @Original_Language)) AND ([Name] = @Original_Name) AND ([AuthorId] = @Original_AuthorId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Language" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Language" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Language" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Language" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AuthorId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="AuthorId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Author] ([Language], [Name], [AuthorId]) VALUES (@Language, @Name, @AuthorId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Language" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Language" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AuthorId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="AuthorId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [Language], [Name], [AuthorId] FROM [Author]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Author] SET [Language] = @Language, [Name] = @Name, [AuthorId] = @AuthorId WHERE (((@IsNull_Language = 1 AND [Language] IS NULL) OR ([Language] = @Original_Language)) AND ([Name] = @Original_Name) AND ([AuthorId] = @Original_AuthorId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Language" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Language" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AuthorId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="AuthorId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Language" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Language" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Language" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Language" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AuthorId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="AuthorId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Language" DataSetColumn="Language" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="AuthorId" DataSetColumn="AuthorId" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM Author
WHERE        (AuthorId = @Original_AuthorId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Original_AuthorId" ColumnName="AuthorId" DataSourceName="main.Author" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@Original_AuthorId" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="AuthorId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetNewId" Modifier="Public" Name="GetNewId" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="GetNewId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        MAX(AuthorId) + 1 AS Expr1
FROM            Author</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="KeysTableAdapter" GeneratorDataComponentClassName="KeysTableAdapter" Name="Keys" UserDataComponentName="KeysTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectName="main.Keys" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Keys] WHERE (([Name] = @Original_Name) AND ([IdKey] = @Original_IdKey))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdKey" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="IdKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Keys] ([Name], [IdKey]) VALUES (@Name, @IdKey)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdKey" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="IdKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [Name], [IdKey] FROM [Keys]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Keys] SET [Name] = @Name, [IdKey] = @IdKey WHERE (([Name] = @Original_Name) AND ([IdKey] = @Original_IdKey))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdKey" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="IdKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdKey" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="IdKey" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="IdKey" DataSetColumn="IdKey" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetNewID" Modifier="Public" Name="GetNewID" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetNewID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        MAX(IdKey) + 1 AS Expr1
FROM            Keys</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [Keys] ([Name], [IdKey]) VALUES (@Name, @IdKey)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Name" ColumnName="Name" DataSourceName="main.Keys" DataTypeServer="nvarchar(30)" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="String" Scale="0" Size="30" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IdKey" ColumnName="IdKey" DataSourceName="main.Keys" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@IdKey" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="IdKey" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TaleTableAdapter" GeneratorDataComponentClassName="TaleTableAdapter" Name="Tale" UserDataComponentName="TaleTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectName="main.Tale" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Tale] WHERE (([IdTale] = @Original_IdTale))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdTale" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="IdTale" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Tale] ([Year], [GroupId], [Printing], [Name], [IdTale], [AuthorId], [Comment]) VALUES (@Year, @GroupId, @Printing, @Name, @IdTale, @AuthorId, @Comment)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Year" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GroupId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="GroupId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Printing" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Printing" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdTale" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="IdTale" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AuthorId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="AuthorId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Year, GroupId, Printing, Name, IdTale, AuthorId, Comment
FROM            Tale
ORDER BY IDTALE DESC </CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Tale] SET [Year] = @Year, [GroupId] = @GroupId, [Printing] = @Printing, [Name] = @Name, [IdTale] = @IdTale, [AuthorId] = @AuthorId, [Comment] = @Comment WHERE (([IdTale] = @Original_IdTale))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Year" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GroupId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="GroupId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Printing" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="Printing" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IdTale" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="IdTale" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AuthorId" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="AuthorId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Comment" Precision="0" ProviderType="String" Scale="0" Size="0" SourceColumn="Comment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IdTale" Precision="0" ProviderType="Int32" Scale="0" Size="0" SourceColumn="IdTale" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Year" DataSetColumn="Year" />
              <Mapping SourceColumn="GroupId" DataSetColumn="GroupId" />
              <Mapping SourceColumn="Printing" DataSetColumn="Printing" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="IdTale" DataSetColumn="IdTale" />
              <Mapping SourceColumn="AuthorId" DataSetColumn="AuthorId" />
              <Mapping SourceColumn="Comment" DataSetColumn="Comment" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillBegin" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetBeginOfData" GeneratorSourceName="FillBegin" GetMethodModifier="Public" GetMethodName="GetBeginOfData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetBeginOfData" UserSourceName="FillBegin">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT AuthorId, Comment, GroupId, IdTale, Name, Printing, Year FROM Tale ORDER BY IdTale DESC limit 50</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectName="main.Tale" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetPerroStat" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetPerroStat" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetPerroStat" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Year, Name, SUM(Printing) AS Expr1
FROM            Tale
WHERE        (AuthorId = 2208) AND (Year BETWEEN @STARTYEAR AND @ENDYEAR)
GROUP BY Year, Name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="STARTYEAR" ColumnName="Year" DataSourceName="main.Tale" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@STARTYEAR" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ENDYEAR" ColumnName="Year" DataSourceName="main.Tale" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@ENDYEAR" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetBookStat" GetMethodModifier="Public" GetMethodName="GetBookStat" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetBookStat" UserSourceName="GetBookStat">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Tale.Year, Keys.Name, COUNT(*) AS Res
FROM            Tale INNER JOIN
                         Keys ON Tale.GroupId = Keys.IdKey
WHERE        (Tale.Year BETWEEN @StartYear AND @EndYear)
GROUP BY Tale.Year, Tale.GroupId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="StartYear" ColumnName="Year" DataSourceName="main.Tale" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@StartYear" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="EndYear" ColumnName="Year" DataSourceName="main.Tale" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@EndYear" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="GetNewID" Modifier="Public" Name="GetNewID" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetNewID">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>select max(IdTale)+1
from Tale</CommandText>
                    <Parameters />
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        MAX(IdTale) + 1 AS Expr1
FROM            Tale</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectName="main.Tale" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetPerroBook" GetMethodModifier="Public" GetMethodName="GetPerroBook" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetPerroBook" UserSourceName="GetPerroBook">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Year, Name, COUNT(*) AS Expr1
FROM            Tale
WHERE        (AuthorId = 2208) AND (Year BETWEEN @STARTYEAR AND @ENDYEAR)
GROUP BY Year, Name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="STARTYEAR" ColumnName="Year" DataSourceName="main.Tale" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@STARTYEAR" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ENDYEAR" ColumnName="Year" DataSourceName="main.Tale" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@ENDYEAR" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetPrintStat" GetMethodModifier="Public" GetMethodName="GetPrintStat" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetPrintStat" UserSourceName="GetPrintStat">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Tale.Year, Keys.Name, SUM(Tale.Printing) AS Printing
FROM            Tale INNER JOIN
                         Keys ON Tale.GroupId = Keys.IdKey
WHERE        (Tale.Year BETWEEN @StartYear AND @EndYear)
GROUP BY Tale.Year, Tale.GroupId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="StartYear" ColumnName="Year" DataSourceName="main.Tale" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@StartYear" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="EndYear" ColumnName="Year" DataSourceName="main.Tale" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@EndYear" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateAuthor" Modifier="Public" Name="UpdateAuthor" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UpdateAuthor">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       Tale
SET                AuthorId = @NewAuthorId
WHERE        (AuthorId = @oldAuthorId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="NewAuthorId" ColumnName="AuthorId" DataSourceName="main.Tale" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@NewAuthorId" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="AuthorId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="oldAuthorId" ColumnName="AuthorId" DataSourceName="main.Tale" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@oldAuthorId" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="AuthorId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Tale_vTableAdapter" GeneratorDataComponentClassName="Tale_vTableAdapter" Name="Tale_v" UserDataComponentName="Tale_vTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectName="main.Tale_v" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [TableName], [AutName], [Year], [Printing], [Key], [Comment] FROM [Tale_v]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="[TableName]" DataSetColumn="[TableName]" />
              <Mapping SourceColumn="[AutName]" DataSetColumn="[AutName]" />
              <Mapping SourceColumn="[Year]" DataSetColumn="[Year]" />
              <Mapping SourceColumn="[Printing]" DataSetColumn="[Printing]" />
              <Mapping SourceColumn="[Key]" DataSetColumn="[Key]" />
              <Mapping SourceColumn="[Comment]" DataSetColumn="[Comment]" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByLess500" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataLess500" GeneratorSourceName="FillByLess500" GetMethodModifier="Public" GetMethodName="GetDataLess500" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataLess500" UserSourceName="FillByLess500">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT [TableName], [AutName], [Year], [Printing], [Key], [Comment] FROM [Tale_v] limit 500
</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DataTable1TableAdapter" GeneratorDataComponentClassName="DataTable1TableAdapter" Name="DataTable1" UserDataComponentName="DataTable1TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetBookStat" GetMethodModifier="Public" GetMethodName="GetBookStat" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetBookStat" UserSourceName="GetBookStat">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Tale.Year, Keys.Name, COUNT(*) AS Books
FROM            Tale INNER JOIN
                         Keys ON Tale.GroupId = Keys.IdKey
where Tale.Year between @StartYear  and @EndYear and Keys.IdKey &lt;&gt;1
GROUP BY Tale.Year, Tale.GroupId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="StartYear" ColumnName="Year" DataSourceName="main.Tale" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@StartYear" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="EndYear" ColumnName="Year" DataSourceName="main.Tale" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@EndYear" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Year" DataSetColumn="Year" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Books" DataSetColumn="Books" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DataTable2TableAdapter" GeneratorDataComponentClassName="DataTable2TableAdapter" Name="DataTable2" UserDataComponentName="DataTable2TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetPrintStat" GetMethodModifier="Public" GetMethodName="GetPrintStat" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetPrintStat" UserSourceName="GetPrintStat">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Tale.Year, Keys.Name, SUM(Tale.Printing) AS Printing
FROM            Tale INNER JOIN
                         Keys ON Tale.GroupId = Keys.IdKey
where Tale.Year between @StartYear and @EndYear and Keys.IdKey &lt;&gt;1
GROUP BY Tale.Year, Tale.GroupId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="StartYear" ColumnName="Year" DataSourceName="main.Tale" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@StartYear" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="EndYear" ColumnName="Year" DataSourceName="main.Tale" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@EndYear" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Year" DataSetColumn="Year" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Printing" DataSetColumn="Printing" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Tale1TableAdapter" GeneratorDataComponentClassName="Tale1TableAdapter" Name="Tale1" UserDataComponentName="Tale1TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectName="main.Tale" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetPerroBooks" GetMethodModifier="Public" GetMethodName="GetPerroBooks" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetPerroBooks" UserSourceName="GetPerroBooks">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT        Year, Name, COUNT(*) AS Res
FROM            Tale
WHERE        (AuthorId = 2208) AND (Year BETWEEN @STARTYEAR AND @ENDYEAR) AND (Name &lt;&gt; '')
GROUP BY Year, Name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="STARTYEAR" ColumnName="Year" DataSourceName="main.Tale" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@STARTYEAR" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ENDYEAR" ColumnName="Year" DataSourceName="main.Tale" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@ENDYEAR" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Year" DataSetColumn="Year" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Res" DataSetColumn="Res" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PerroPrintingTableAdapter" GeneratorDataComponentClassName="PerroPrintingTableAdapter" Name="PerroPrinting" UserDataComponentName="PerroPrintingTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectName="main.Tale" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        Year, Name, SUM(Printing) AS Printing
FROM            Tale
WHERE        (AuthorId = 2208) AND (Year BETWEEN @STARTYEAR AND @ENDYEAR) and Name &lt;&gt; ''
GROUP BY Year, Name</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="STARTYEAR" ColumnName="Year" DataSourceName="main.Tale" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@STARTYEAR" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="ENDYEAR" ColumnName="Year" DataSourceName="main.Tale" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@ENDYEAR" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Year" DataSetColumn="Year" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Printing" DataSetColumn="Printing" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources>
          <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateAthor" MethodsParameterType="CLR" Modifier="Public" Name="UpdateAthor" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="UpdateAthor">
            <SelectCommand>
              <DbCommand CommandType="Text" ModifiedByUser="true">
                <CommandText>UPDATE       Tale
SET                AuthorId = @NewAuthorId
WHERE        (AuthorId = @oldAuthorId)</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="NewAuthorId" ColumnName="AuthorId" DataSourceName="main.Tale" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@NewAuthorId" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="AuthorId" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="oldAuthorId" ColumnName="AuthorId" DataSourceName="main.Tale" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@oldAuthorId" Precision="0" ProviderType="Int32" Scale="0" Size="4" SourceColumn="AuthorId" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectName="main.Keys" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetGroupId" MethodsParameterType="CLR" Modifier="Public" Name="GetGroupId" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="GetGroupId">
            <SelectCommand>
              <DbCommand CommandType="Text" ModifiedByUser="true">
                <CommandText>SELECT        IdKey
FROM            Keys
WHERE        (upper(Name) = upper(@Group))</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="false" AutogeneratedName="Group" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@Group" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="TalesConnectionString (Settings)" DbObjectName="main.Author" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetAithorId" MethodsParameterType="CLR" Modifier="Public" Name="GetAithorId" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="GetAithorId">
            <SelectCommand>
              <DbCommand CommandType="Text" ModifiedByUser="true">
                <CommandText>SELECT        AuthorId
FROM            Author
WHERE        (upper(Name) =upper( @Name))</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="false" AutogeneratedName="Name" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" Scale="0" Size="1024" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="TalesDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="TalesDataSet" msprop:Generator_UserDSName="TalesDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Author" msprop:Generator_TableClassName="AuthorDataTable" msprop:Generator_TableVarName="tableAuthor" msprop:Generator_RowChangedName="AuthorRowChanged" msprop:Generator_TablePropName="Author" msprop:Generator_RowDeletingName="AuthorRowDeleting" msprop:Generator_RowChangingName="AuthorRowChanging" msprop:Generator_RowEvHandlerName="AuthorRowChangeEventHandler" msprop:Generator_RowDeletedName="AuthorRowDeleted" msprop:Generator_RowClassName="AuthorRow" msprop:Generator_UserTableName="Author" msprop:Generator_RowEvArgName="AuthorRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Language" msprop:Generator_ColumnVarNameInTable="columnLanguage" msprop:Generator_ColumnPropNameInRow="Language" msprop:Generator_ColumnPropNameInTable="LanguageColumn" msprop:Generator_UserColumnName="Language" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AuthorId" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnAuthorId" msprop:Generator_ColumnPropNameInRow="AuthorId" msprop:Generator_ColumnPropNameInTable="AuthorIdColumn" msprop:Generator_UserColumnName="AuthorId" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Keys" msprop:Generator_TableClassName="KeysDataTable" msprop:Generator_TableVarName="tableKeys" msprop:Generator_RowChangedName="KeysRowChanged" msprop:Generator_TablePropName="Keys" msprop:Generator_RowDeletingName="KeysRowDeleting" msprop:Generator_RowChangingName="KeysRowChanging" msprop:Generator_RowEvHandlerName="KeysRowChangeEventHandler" msprop:Generator_RowDeletedName="KeysRowDeleted" msprop:Generator_RowClassName="KeysRow" msprop:Generator_UserTableName="Keys" msprop:Generator_RowEvArgName="KeysRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdKey" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIdKey" msprop:Generator_ColumnPropNameInRow="IdKey" msprop:Generator_ColumnPropNameInTable="IdKeyColumn" msprop:Generator_UserColumnName="IdKey" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Tale" msprop:Generator_TableClassName="TaleDataTable" msprop:Generator_TableVarName="tableTale" msprop:Generator_RowChangedName="TaleRowChanged" msprop:Generator_TablePropName="Tale" msprop:Generator_RowDeletingName="TaleRowDeleting" msprop:Generator_RowChangingName="TaleRowChanging" msprop:Generator_RowEvHandlerName="TaleRowChangeEventHandler" msprop:Generator_RowDeletedName="TaleRowDeleted" msprop:Generator_RowClassName="TaleRow" msprop:Generator_UserTableName="Tale" msprop:Generator_RowEvArgName="TaleRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Year" msprop:Generator_ColumnVarNameInTable="columnYear" msprop:Generator_ColumnPropNameInRow="Year" msprop:Generator_ColumnPropNameInTable="YearColumn" msprop:Generator_UserColumnName="Year" type="xs:int" />
              <xs:element name="GroupId" msprop:Generator_ColumnVarNameInTable="columnGroupId" msprop:Generator_ColumnPropNameInRow="GroupId" msprop:Generator_ColumnPropNameInTable="GroupIdColumn" msprop:Generator_UserColumnName="GroupId" type="xs:int" />
              <xs:element name="Printing" msprop:Generator_ColumnVarNameInTable="columnPrinting" msprop:Generator_ColumnPropNameInRow="Printing" msprop:Generator_ColumnPropNameInTable="PrintingColumn" msprop:Generator_UserColumnName="Printing" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdTale" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIdTale" msprop:Generator_ColumnPropNameInRow="IdTale" msprop:Generator_ColumnPropNameInTable="IdTaleColumn" msprop:Generator_UserColumnName="IdTale" type="xs:int" />
              <xs:element name="AuthorId" msprop:Generator_ColumnVarNameInTable="columnAuthorId" msprop:Generator_ColumnPropNameInRow="AuthorId" msprop:Generator_ColumnPropNameInTable="AuthorIdColumn" msprop:Generator_UserColumnName="AuthorId" type="xs:int" minOccurs="0" />
              <xs:element name="Comment" msprop:Generator_ColumnVarNameInTable="columnComment" msprop:Generator_ColumnPropNameInRow="Comment" msprop:Generator_ColumnPropNameInTable="CommentColumn" msprop:Generator_UserColumnName="Comment" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Tale_v" msprop:Generator_TableClassName="Tale_vDataTable" msprop:Generator_TableVarName="tableTale_v" msprop:Generator_RowChangedName="Tale_vRowChanged" msprop:Generator_TablePropName="Tale_v" msprop:Generator_RowDeletingName="Tale_vRowDeleting" msprop:Generator_RowChangingName="Tale_vRowChanging" msprop:Generator_RowEvHandlerName="Tale_vRowChangeEventHandler" msprop:Generator_RowDeletedName="Tale_vRowDeleted" msprop:Generator_RowClassName="Tale_vRow" msprop:Generator_UserTableName="Tale_v" msprop:Generator_RowEvArgName="Tale_vRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="_x005B_TableName_x005D_" msprop:Generator_ColumnVarNameInTable="_column_TableName_" msprop:Generator_ColumnPropNameInRow="__TableName_" msprop:Generator_ColumnPropNameInTable="__TableName_Column" msprop:Generator_UserColumnName="[TableName]">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="_x005B_AutName_x005D_" msprop:Generator_ColumnVarNameInTable="_column_AutName_" msprop:Generator_ColumnPropNameInRow="__AutName_" msprop:Generator_ColumnPropNameInTable="__AutName_Column" msprop:Generator_UserColumnName="[AutName]">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="_x005B_Year_x005D_" msprop:Generator_ColumnVarNameInTable="_column_Year_" msprop:Generator_ColumnPropNameInRow="__Year_" msprop:Generator_ColumnPropNameInTable="__Year_Column" msprop:Generator_UserColumnName="[Year]" type="xs:int" />
              <xs:element name="_x005B_Printing_x005D_" msprop:Generator_ColumnVarNameInTable="_column_Printing_" msprop:Generator_ColumnPropNameInRow="__Printing_" msprop:Generator_ColumnPropNameInTable="__Printing_Column" msprop:Generator_UserColumnName="[Printing]" type="xs:int" />
              <xs:element name="_x005B_Key_x005D_" msprop:Generator_ColumnVarNameInTable="_column_Key_" msprop:Generator_ColumnPropNameInRow="__Key_" msprop:Generator_ColumnPropNameInTable="__Key_Column" msprop:Generator_UserColumnName="[Key]">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="_x005B_Comment_x005D_" msprop:Generator_ColumnVarNameInTable="_column_Comment_" msprop:Generator_ColumnPropNameInRow="__Comment_" msprop:Generator_ColumnPropNameInTable="__Comment_Column" msprop:Generator_UserColumnName="[Comment]" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DataTable1" msprop:Generator_TableClassName="DataTable1DataTable" msprop:Generator_TableVarName="tableDataTable1" msprop:Generator_RowChangedName="DataTable1RowChanged" msprop:Generator_TablePropName="DataTable1" msprop:Generator_RowDeletingName="DataTable1RowDeleting" msprop:Generator_RowChangingName="DataTable1RowChanging" msprop:Generator_RowEvHandlerName="DataTable1RowChangeEventHandler" msprop:Generator_RowDeletedName="DataTable1RowDeleted" msprop:Generator_RowClassName="DataTable1Row" msprop:Generator_UserTableName="DataTable1" msprop:Generator_RowEvArgName="DataTable1RowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Year" msprop:Generator_ColumnVarNameInTable="columnYear" msprop:Generator_ColumnPropNameInRow="Year" msprop:Generator_ColumnPropNameInTable="YearColumn" msprop:Generator_UserColumnName="Year" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Books" msprop:Generator_ColumnVarNameInTable="columnBooks" msprop:Generator_ColumnPropNameInRow="Books" msprop:Generator_ColumnPropNameInTable="BooksColumn" msprop:Generator_UserColumnName="Books" type="xs:anyType" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DataTable2" msprop:Generator_TableClassName="DataTable2DataTable" msprop:Generator_TableVarName="tableDataTable2" msprop:Generator_RowChangedName="DataTable2RowChanged" msprop:Generator_TablePropName="DataTable2" msprop:Generator_RowDeletingName="DataTable2RowDeleting" msprop:Generator_RowChangingName="DataTable2RowChanging" msprop:Generator_RowEvHandlerName="DataTable2RowChangeEventHandler" msprop:Generator_RowDeletedName="DataTable2RowDeleted" msprop:Generator_RowClassName="DataTable2Row" msprop:Generator_UserTableName="DataTable2" msprop:Generator_RowEvArgName="DataTable2RowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Year" msprop:Generator_ColumnVarNameInTable="columnYear" msprop:Generator_ColumnPropNameInRow="Year" msprop:Generator_ColumnPropNameInTable="YearColumn" msprop:Generator_UserColumnName="Year" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Printing" msprop:Generator_ColumnVarNameInTable="columnPrinting" msprop:Generator_ColumnPropNameInRow="Printing" msprop:Generator_ColumnPropNameInTable="PrintingColumn" msprop:Generator_UserColumnName="Printing" type="xs:anyType" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Tale1" msprop:Generator_TableClassName="Tale1DataTable" msprop:Generator_TableVarName="tableTale1" msprop:Generator_RowChangedName="Tale1RowChanged" msprop:Generator_TablePropName="Tale1" msprop:Generator_RowDeletingName="Tale1RowDeleting" msprop:Generator_RowChangingName="Tale1RowChanging" msprop:Generator_RowEvHandlerName="Tale1RowChangeEventHandler" msprop:Generator_RowDeletedName="Tale1RowDeleted" msprop:Generator_RowClassName="Tale1Row" msprop:Generator_UserTableName="Tale1" msprop:Generator_RowEvArgName="Tale1RowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Year" msprop:Generator_ColumnVarNameInTable="columnYear" msprop:Generator_ColumnPropNameInRow="Year" msprop:Generator_ColumnPropNameInTable="YearColumn" msprop:Generator_UserColumnName="Year" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Res" msprop:Generator_ColumnVarNameInTable="columnRes" msprop:Generator_ColumnPropNameInRow="Res" msprop:Generator_ColumnPropNameInTable="ResColumn" msprop:Generator_UserColumnName="Res" type="xs:anyType" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PerroPrinting" msprop:Generator_TableClassName="PerroPrintingDataTable" msprop:Generator_TableVarName="tablePerroPrinting" msprop:Generator_RowChangedName="PerroPrintingRowChanged" msprop:Generator_TablePropName="PerroPrinting" msprop:Generator_RowDeletingName="PerroPrintingRowDeleting" msprop:Generator_RowChangingName="PerroPrintingRowChanging" msprop:Generator_RowEvHandlerName="PerroPrintingRowChangeEventHandler" msprop:Generator_RowDeletedName="PerroPrintingRowDeleted" msprop:Generator_RowClassName="PerroPrintingRow" msprop:Generator_UserTableName="PerroPrinting" msprop:Generator_RowEvArgName="PerroPrintingRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Year" msprop:Generator_ColumnVarNameInTable="columnYear" msprop:Generator_ColumnPropNameInRow="Year" msprop:Generator_ColumnPropNameInTable="YearColumn" msprop:Generator_UserColumnName="Year" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Printing" msprop:Generator_ColumnVarNameInTable="columnPrinting" msprop:Generator_ColumnPropNameInRow="Printing" msprop:Generator_ColumnPropNameInTable="PrintingColumn" msprop:Generator_UserColumnName="Printing" type="xs:anyType" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Keys" />
      <xs:field xpath="mstns:IdKey" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="Author_Tale" msdata:parent="Author" msdata:child="Tale" msdata:parentkey="AuthorId" msdata:childkey="AuthorId" msprop:Generator_UserChildTable="Tale" msprop:Generator_ChildPropName="GetTaleRows" msprop:Generator_UserRelationName="Author_Tale" msprop:Generator_RelationVarName="relationAuthor_Tale" msprop:Generator_UserParentTable="Author" msprop:Generator_ParentPropName="AuthorRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>